
<cfquery name="shout" datasource="shout">
    SELECT *
FROM `messages`
ORDER BY datedon DESC
LIMIT 0 , 30
    
</cfquery>

<div class="post">
    <div class="postheader"><h1>Shout Box</h1></div>
    <div class="postcontent">
    
<table cellpadding="2" cellspacing="2" class="box" width="100%">
    <cfoutput query="shout" maxrows="10">
    <tr>
        <td valign="top">
			<cfset pDate = #DateFormat(datedon, "d/m/yy")#>
            <cfset pTime = #TimeFormat(datedon, "hh:mm:sstt")#>
            <cfset date = "#pDate# - #pTime# ">

			<p><a href="mailto:#email#" title="#date#">#poster#</a>: #date# - #msg#</p>
        </td>
    </tr>
    <tr>
        <td>
           <hr width="100%">
        </td>
    </tr>
    </cfoutput>
</table> 

<hr>
<br>
<form method="post" action="_inc/addshout.cfm">
  <font size="2" family="Verdana">
    <p>Name:</p>
    <input type="text" name="poster">
    <br>
   <p>E-mail:</p>
    <input type="text" name="email">
    <br>
    <p>Message:</p>
    <textarea name="msg" rows="4" cols="50"></textarea>
    <br>
    <br>
    <input type="submit" value="add shout">
</form> 
</div>
    <div class="postfooter"></div>
</div>